<!DOCTYPE html>
<html lang="en">
    <head>
        <!--
                Author: Jeffric Alexander Fuentes Heiz
                Date: 30/06/2013 12:24 a.m. 
        -->
        <%@page import="java.io.IOException"%>
        <%@page import="java.io.FileWriter"%>
        <%@page import="java.sql.DriverManager"%>
        <%@page import="javax.swing.table.DefaultTableModel"%>
        <%@page import="java.sql.ResultSet"%>
        <%@page import="java.sql.Statement"%>
        <%@page import="java.sql.Connection"%>
        <%@ page import="java.util.*" %>
        <%@ page import="java.text.SimpleDateFormat"%>
        <%@page contentType="text/html" pageEncoding="UTF-8"%>
        <meta charset="utf-8">
        <title>EduShare - Busqueda</title>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="Charisma, a fully featured, responsive, HTML5, Bootstrap admin template.">
        <meta name="author" content="Muhammad Usman">

        <!-- The styles -->
        <link id="bs-css" href="css/bootstrap-cerulean.css" rel="stylesheet">
        <style type="text/css">
            body {
                padding-bottom: 40px;
            }
            .sidebar-nav {
                padding: 9px 0;
            }
        </style>
        <link href="css/bootstrap-responsive.css" rel="stylesheet">
        <link href="css/charisma-app.css" rel="stylesheet">
        <link href="css/jquery-ui-1.8.21.custom.css" rel="stylesheet">
        <link href='css/fullcalendar.css' rel='stylesheet'>
        <link href='css/fullcalendar.print.css' rel='stylesheet'  media='print'>
        <link href='css/chosen.css' rel='stylesheet'>
        <link href='css/uniform.default.css' rel='stylesheet'>
        <link href='css/colorbox.css' rel='stylesheet'>
        <link href='css/jquery.cleditor.css' rel='stylesheet'>
        <link href='css/jquery.noty.css' rel='stylesheet'>
        <link href='css/noty_theme_default.css' rel='stylesheet'>
        <link href='css/elfinder.min.css' rel='stylesheet'>
        <link href='css/elfinder.theme.css' rel='stylesheet'>
        <link href='css/jquery.iphone.toggle.css' rel='stylesheet'>
        <link href='css/opa-icons.css' rel='stylesheet'>
        <link href='css/uploadify.css' rel='stylesheet'>

        <!-- The HTML5 shim, for IE6-8 support of HTML5 elements -->
        <!--[if lt IE 9]>
          <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
        <![endif]-->

        <!-- The fav icon -->
        <link rel="shortcut icon" href="img/favicon.ico">

    </head>
    <% String _id_usuario = (String) session.getAttribute("id_usuario");
        String _correo_usuario = (String) session.getAttribute("correo");
        String _tipo_usuario = (String) session.getAttribute("tipoUsuario");
        if (_id_usuario != null || true) {
    %>

    <body>
        <!-- topbar starts -->
        <div class="navbar">
            <div class="navbar-inner">
                <div class="container-fluid">
                    <a class="btn btn-navbar" data-toggle="collapse" data-target=".top-nav.nav-collapse,.sidebar-nav.nav-collapse">
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </a>
                    <a class="brand" href="index.html"> <img alt="Charisma Logo" src="img/logo20.png" /> <span>EduShare</span></a>			      

                    <!--/span-->


                    <!-- user dropdown starts -->
                    <div class="btn-group pull-right" >

                        <%
                            String correoUsuario = null;
                            //si hay una sesion activa
                            if (session != null && session.getAttribute("correo") != null) {

                                //tomar el valor del correo del usuario
                                correoUsuario = session.getAttribute("correo").toString();
                                //colocar el html para mostra el usuario y el dropdown
%>
                        <a class="btn dropdown-toggle" data-toggle="dropdown" href="#">
                            <i class="icon-user"></i><span class="hidden-phone"><%= correoUsuario%></span>
                            <span class="caret"></span>
                        </a>
                        <ul class="dropdown-menu">
                            <li><a href="perfil.jsp">Perfil</a></li>
                            <li class="divider"></li>
                            <li><a href="index.jsp?cs=true">Logout</a></li>
                        </ul>
                        <%} //si no hay una session activa
                        else {%>
                        <a class="btn dropdown-toggle" data-toggle="dropdown" href="login.jsp">
                            <i class="icon-user"></i><span class="hidden-phone">Login/Registro</span>
                            <span class="caret"></span>
                        </a>
                        <ul class="dropdown-menu">
                            <li><a href="login.jsp">Login</a></li>                            
                        </ul>
                        <%}%>
                    </div>
                </div>
            </div>
        </div>


        <!-- topbar ends -->
        <div class="container-fluid">
            <div class="row-fluid">

                <!-- left menu starts -->
                <div class="span2 main-menu-span">
                    <div class="well nav-collapse sidebar-nav">
                        <ul class="nav nav-tabs nav-stacked main-menu">
                            <li class="nav-header hidden-tablet">Menú</li>
                            <li><a class="ajax-link" href="index.jsp"><i class="icon-home"></i><span class="hidden-tablet">Inicio</span></a></li>						
                            <!-- href de form.html a articulo.html-->
                            <li><a class="ajax-link" href="articulo.jsp"><i class="icon-edit"></i><span class="hidden-tablet">Nuevo Artículo</span></a></li>
                            <!-- href de chart.html a reporte.html-->
                            <li><a class="ajax-link" href="reporte.jsp"><i class="icon-list-alt"></i><span class="hidden-tablet">Reportes</span></a></li>
                            <!-- href de table.html a busqueda.html-->
                            <li><a class="ajax-link" href="busqueda.jsp"><i class="icon-align-justify"></i><span class="hidden-tablet">Buscar</span></a></li>
                            <!-- (agregado) href a administrar.html-->
                            <li><a class="ajax-link" href="administrar.jsp"><i class="icon-align-justify"></i><span class="hidden-tablet">Administrar</span></a></li>                           
                        </ul>

                    </div><!--/.well -->
                </div><!--/span-->
                <!-- left menu ends -->

                <noscript>
                <div class="alert alert-block span10">
                    <h4 class="alert-heading">Warning!</h4>
                    <p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
                </div>
                </noscript>
                <div id="content" class="span10">
                    <!-- content starts -->


                    <div>
                        <ul class="breadcrumb">
                            <li>
                                <a href="#">Inicio</a> <span class="divider">/</span>
                            </li>
                            <li>
                                <a href="#">Busqueda</a>
                            </li>
                        </ul>
                    </div>

                    <div class="row-fluid sortable">		
                        <div class="box span12">
                            <div class="box-header well" data-original-title>
                                <h2><i class="icon-book"></i> Busqueda de Articulos</h2>
                                <div class="box-icon">
                                    <a href="#" class="btn btn-setting btn-round"><i class="icon-cog"></i></a>
                                    <a href="#" class="btn btn-minimize btn-round"><i class="icon-chevron-up"></i></a>
                                    <a href="#" class="btn btn-close btn-round"><i class="icon-remove"></i></a>
                                </div>
                            </div>
                            <div class="box-content">
                                <table class="table table-striped table-bordered bootstrap-datatable datatable">

                                    <thead>
                                        <tr>
                                            <th>Titulo</th>
                                            <th>Autor</th>
                                            <th>Categorias del articulo</th>
                                            <th>Descripcion</th>
                                            <th>Fecha de creacion</th>
                                            <th>Fecha de Modificacion</th>
                                            <th>Acciones</th>
                                        </tr>
                                    </thead>   
                                    <tbody>

                                        <%
                                            //aqui vamos a llenar toda la tabla con un query, seleccionando todos los articulos disponibles
                                            //dentro de la base de datos.                                             
                                            /*String user = "root";
                                             String clave = "12345";
                                             String ruta = "jdbc:mysql://10.0.0.4/ayd2bd";*/
                                            String user = "sql312735";
                                            String clave = "sH9!yN8%";
                                            String ruta = "jdbc:mysql://sql3.freemysqlhosting.net:3306/sql312735";
                                            Connection conexion = null;
                                            Statement Sentencias = null;
                                            ResultSet tabla = null;
                                            try {
                                                Class.forName("com.mysql.jdbc.Driver").newInstance();
                                                conexion = DriverManager.getConnection(ruta, user, clave);
                                                Sentencias = conexion.createStatement();
                                            } catch (Exception e) {
                                                out.println("<script>alert('Error de Conexion')</script>");
                                                e.printStackTrace();
                                            }
                                            String _titulo = null;
                                            String _autor = null;
                                            String _fecha_hora_publicacion = null;

                                            String _descripcion = null;
                                            String _id_articulo = null;
                                            try {
                                                //                                        tabla = Sentencias.executeQuery("select titulo,punteo,fecha_hora_publicacion,ubicacion_actual,descripcion from ayd2bd.ARTICULO");
                                                tabla = Sentencias.executeQuery("SELECT ARTICULO.id_articulo AS 'id de Articulo', ARTICULO.titulo AS 'Titulo', "
                                                        + "USUARIO.nombre AS 'Autor', ARTICULO.descripcion AS 'Descripcion', ARTICULO.fecha_hora_publicacion AS 'fecha de publicacion' "
                                                        + "FROM ARTICULO JOIN USUARIO ON ( ARTICULO.id_usuario = USUARIO.id_usuario )");

                                                while (tabla.next()) {
                                                    String _fecha_modificacion = null;
                                                    String _categorias = null;
                                                    ResultSet tabla2 = null;
                                                    Statement Sentencias2 = null;
                                                    Sentencias2 = conexion.createStatement();
                                                    _titulo = tabla.getString("Titulo");
                                                    _id_articulo = tabla.getString("id de Articulo");
                                                    _autor = tabla.getString("Autor");
                                                    _fecha_hora_publicacion = tabla.getString("fecha de publicacion");
                                                    _descripcion = tabla.getString("Descripcion");

                                                    //sacamos la fecha de la ultima modificacion de un articulo, por medio del id recuperado
                                                    //anteriormente
                                                    Statement Sentencias3 = null;
                                                    ResultSet tabla3 = null;
                                                    Sentencias3 = conexion.createStatement();
                                                    tabla3 = Sentencias3.executeQuery("SELECT EDICION.fecha_hora FROM EDICION WHERE EDICION.id_version "
                                                            + "IN (SELECT VERSION.id_version FROM VERSION WHERE VERSION.id_articulo =" + _id_articulo + ") "
                                                            + "ORDER BY EDICION.fecha_hora DESC "
                                                            + "LIMIT 0 , 1");

                                                    while (tabla3.next()) {
                                                        _fecha_modificacion = tabla3.getString("fecha_hora");
                                                        break;
                                                    }
                                                    //vamos a sacar las categorias de cada id
                                                    tabla2 = Sentencias2.executeQuery("SELECT CATEGORIA.nombre FROM CATEGORIA "
                                                            + "JOIN ETIQUETA ON ( ETIQUETA.id_categoria = CATEGORIA.id_categoria "
                                                            + "AND ETIQUETA.id_articulo =" + _id_articulo + ")");

                                                    while (tabla2.next()) {
                                                        if (_categorias == null) {
                                                            _categorias = tabla2.getString("nombre");
                                                        } else {
                                                            _categorias = _categorias + ", " + tabla2.getString("nombre");
                                                        }
                                                    }

                                                    out.print("<tr>");
                                                    out.print("<td>" + _titulo + "</td>");
                                                    out.print("<td class=\"center\">" + _autor + "</td>");
                                                    if (_categorias == null) {
                                                        _categorias = "[Sin Categorias]";
                                                    }

                                                    if (_fecha_modificacion == null) {
                                                        _fecha_modificacion = "[Este articulo no ha tenido modificaciones]";
                                                    }

                                                    out.print("<td class=\"center\">" + _categorias + "</td>");
                                                    out.print("<td class=\"center\">" + _descripcion + "</td>");
                                                    out.print("<td class=\"center\">" + _fecha_hora_publicacion + "</td>");
                                                    out.print("<td class=\"center\">" + _fecha_modificacion + "</td>");
                                                    //comprobar el tipo de usuario, para habilitarle el boton de editar
                                                    if (_tipo_usuario == null || _tipo_usuario.equalsIgnoreCase("Lector")) {
                                                        out.print("<td colspan=\"2\" align=\"center\" nowrap=\"nowrap\">"
                                                                + "<form action=\"POST\"><a class=\"btn btn-success\" "
                                                                + "href=\"visorDeArticulo.jsp?id_articulo=" + _id_articulo + "\"><i class=\"icon-zoom-in "
                                                                + "icon-white\"></i>Ver </a></form></td>");
                                                    } else {

                                                        out.print("<td colspan=\"2\" align=\"center\" nowrap=\"nowrap\">"
                                                                + "<form action=\"POST\"><a class=\"btn btn-success\" "
                                                                + "href=\"visorDeArticulo.jsp?id_articulo=" + _id_articulo + "\"><i class=\"icon-zoom-in "
                                                                + "icon-white\"></i>Ver </a><a class=\"btn btn-info\" href=\"editar.jsp?id_articulo=" + _id_articulo + "\">"
                                                                + "<i class=\"icon-edit icon-white\"></i>Editar</a></form></td>");
                                                    }
                                                }
                                                //luego comparamos si es uno es usuario existente y bien validado sino error


                                            } catch (Exception e) {
                                                out.println("<script>alert('Error')</script>");
                                                e.printStackTrace();
                                            }
                                        %>
                                    </tbody>
                                </table>            
                            </div>
                        </div><!--/span-->

                    </div><!--/row-->

                </div><!--/row-->

                <div class="row-fluid sortable">	


                </div><!--/row-->

                <!-- content ends -->
            </div><!--/#content.span10-->
        </div><!--/fluid-row-->

        <hr>

        <div class="modal hide fade" id="myModal">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">×</button>
                <h3>Settings</h3>
            </div>
            <div class="modal-body">
                <p>Here settings can be configured...</p>
            </div>
            <div class="modal-footer">
                <a href="#" class="btn" data-dismiss="modal">Close</a>
                <a href="#" class="btn btn-primary">Save changes</a>
            </div>
        </div>

        <footer>

            <p class="pull-right">Powered by: <a href="http://usman.it/free-responsive-admin-template">EduShare</a></p>
        </footer>

    </div><!--/.fluid-container-->

    <!-- external javascript-->
    <!-- Placed at the end of the document so the pages load faster -->

    <!-- jQuery -->
    <script src="js/jquery-1.7.2.min.js"></script>
    <!-- jQuery UI -->
    <script src="js/jquery-ui-1.8.21.custom.min.js"></script>
    <!-- transition / effect library -->
    <script src="js/bootstrap-transition.js"></script>
    <!-- alert enhancer library -->
    <script src="js/bootstrap-alert.js"></script>
    <!-- modal / dialog library -->
    <script src="js/bootstrap-modal.js"></script>
    <!-- custom dropdown library -->
    <script src="js/bootstrap-dropdown.js"></script>
    <!-- scrolspy library -->
    <script src="js/bootstrap-scrollspy.js"></script>
    <!-- library for creating tabs -->
    <script src="js/bootstrap-tab.js"></script>
    <!-- library for advanced tooltip -->
    <script src="js/bootstrap-tooltip.js"></script>
    <!-- popover effect library -->
    <script src="js/bootstrap-popover.js"></script>
    <!-- button enhancer library -->
    <script src="js/bootstrap-button.js"></script>
    <!-- accordion library (optional, not used in demo) -->
    <script src="js/bootstrap-collapse.js"></script>
    <!-- carousel slideshow library (optional, not used in demo) -->
    <script src="js/bootstrap-carousel.js"></script>
    <!-- autocomplete library -->
    <script src="js/bootstrap-typeahead.js"></script>
    <!-- tour library -->
    <script src="js/bootstrap-tour.js"></script>
    <!-- library for cookie management -->
    <script src="js/jquery.cookie.js"></script>
    <!-- calander plugin -->
    <script src='js/fullcalendar.min.js'></script>
    <!-- data table plugin -->
    <script src='js/jquery.dataTables.min.js'></script>

    <!-- chart libraries start -->
    <script src="js/excanvas.js"></script>
    <script src="js/jquery.flot.min.js"></script>
    <script src="js/jquery.flot.pie.min.js"></script>
    <script src="js/jquery.flot.stack.js"></script>
    <script src="js/jquery.flot.resize.min.js"></script>
    <!-- chart libraries end -->

    <!-- select or dropdown enhancer -->
    <script src="js/jquery.chosen.min.js"></script>
    <!-- checkbox, radio, and file input styler -->
    <script src="js/jquery.uniform.min.js"></script>
    <!-- plugin for gallery image view -->
    <script src="js/jquery.colorbox.min.js"></script>
    <!-- rich text editor library -->
    <script src="js/jquery.cleditor.min.js"></script>
    <!-- notification plugin -->
    <script src="js/jquery.noty.js"></script>
    <!-- file manager library -->
    <script src="js/jquery.elfinder.min.js"></script>
    <!-- star rating plugin -->
    <script src="js/jquery.raty.min.js"></script>
    <!-- for iOS style toggle switch -->
    <script src="js/jquery.iphone.toggle.js"></script>
    <!-- autogrowing textarea plugin -->
    <script src="js/jquery.autogrow-textarea.js"></script>
    <!-- multiple file upload plugin -->
    <script src="js/jquery.uploadify-3.1.min.js"></script>
    <!-- history.js for cross-browser state change on ajax -->
    <script src="js/jquery.history.js"></script>
    <!-- application script for Charisma demo -->
    <script src="js/charisma.js"></script>


</body>
<%
    } else {
        response.sendRedirect("index.jsp");
        //out.println("<script>alert('Inicie sesión para poder ver esta página') </script>");
        //out.println("<script>window.location = \"index.jsp\" </script>");

    }
%>
</html>
